US Power Plants Meta Analysis
Contents
import pandas as pd
import matplotlib.pyplot as plt
import geopandas as gpd
from folium import plugins
import folium
pd.set_option('display.float_format', lambda x: '%0.4f' % x)
/Users/jnapolitano/venvs/sphinx-build/lib/python3.9/site-packages/geopandas/_compat.py:111: UserWarning: The Shapely GEOS version (3.10.2-CAPI-1.16.0) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow.
warnings.warn(
US Power Plants Meta Analysis¶
US Power Plants Data¶
gisfilepath = "/Users/jnapolitano/Projects/freight.jnapolitano.io/source/data/Power_Plants.geojson"
powerplants_df = gpd.read_file(gisfilepath)
#Selecting only Operational Plants
powerplants_df=powerplants_df.loc[powerplants_df['STATUS'] == 'OP'].copy()
#powerplants_df = powerplants_df.to_crs(epsg=3857)
powerplants_df
| OBJECTID | PLANT_CODE | NAME | ADDRESS | CITY | STATE | ZIP | TELEPHONE | TYPE | STATUS | ... | NGAS_USED | OIL_USED | NET_GEN | CAP_FACTOR | SUB_1 | SUB_2 | LINES | SOURCE_LAT | SOURC_LONG | geometry | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 10504 | AMALGAMATED SUGAR TWIN FALLS | 2320 ORCHARD DRIVE EAST | TWIN FALLS | ID | 83301 | NOT AVAILABLE | CONVENTIONAL STEAM COAL | OP | ... | 1281711 | 0 | 51971.0000 | 0.6980 | NOT AVAILABLE | NOT AVAILABLE | 0 | 42.5325 | -114.4320 | POINT (-114.43202 42.53255) |
| 2 | 3 | 7458 | RUEDI | 14151 FRYING PAN ROAD | ASPEN | CO | 81611 | NOT AVAILABLE | CONVENTIONAL HYDROELECTRIC | OP | ... | 0 | 0 | 22690.0000 | 0.5756 | NOT AVAILABLE | NOT AVAILABLE | 0 | 39.3631 | -106.8219 | POINT (-106.82194 39.36311) |
| 3 | 4 | 6204 | LARAMIE RIVER STATION | HWY 320 | WHEATLAND | WY | 82201 | NOT AVAILABLE | CONVENTIONAL STEAM COAL | OP | ... | 0 | 37956 | 10282950.0000 | 0.6865 | LARAMIE RIVER | NOT AVAILABLE | 3 | 42.1091 | -104.8839 | POINT (-104.88388 42.10906) |
| 4 | 5 | 8028 | ARVADA | HWY 14 | ARVADA | WY | 82831 | NOT AVAILABLE | NATURAL GAS FIRED COMBUSTION TURBINE | OP | ... | 2492 | 0 | 165.0000 | 0.0013 | UNKNOWN204352 | NOT AVAILABLE | 1 | 44.6938 | -105.9777 | POINT (-105.97772 44.69378) |
| 5 | 6 | 8026 | HARTZOG | HWY 50 | WRIGHT | WY | 82732 | NOT AVAILABLE | NATURAL GAS FIRED COMBUSTION TURBINE | OP | ... | 6018 | 0 | 370.0000 | 0.0028 | UNKNOWN201474 | NOT AVAILABLE | 1 | 43.7734 | -105.7808 | POINT (-105.78081 43.77335) |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 11805 | 11806 | 60487 | RIVER ROAD SOLAR, LLC | 951 RIVER ROAD | COFIELD | NC | 27922 | NOT AVAILABLE | SOLAR PHOTOVOLTAIC | OP | ... | 0 | 0 | 7833.0000 | 0.1788 | NOT AVAILABLE | NOT AVAILABLE | 0 | 36.3510 | -76.8420 | POINT (-76.86189 36.36233) |
| 11806 | 11807 | 2720 | BUCK | 1555 DUKEVILLE RD | SALISBURY | NC | 28145 | (704) 382-4327 | CONVENTIONAL STEAM COAL; NATURAL GAS FIRED COM... | OP | ... | 35735577 | 0 | 5173061.0000 | 0.8840 | UNKNOWN114701 | TAP169920 | 1 | 35.7133 | -80.3767 | POINT (-80.37562 35.70790) |
| 11807 | 11808 | 56587 | MINNESOTA BREEZE LLC | 28431 KING AVENUE | RUSHMORE | MN | 56168 | NOT AVAILABLE | ONSHORE WIND TURBINE | OP | ... | 0 | 0 | 2892.0000 | 0.2540 | NOT AVAILABLE | NOT AVAILABLE | 0 | 43.5833 | -95.7781 | POINT (-95.77810 43.58330) |
| 11808 | 11809 | 62139 | HUNEKE II CSG | 45000 145TH AVENUE | ZUMBROTA | MN | 55992 | NOT AVAILABLE | SOLAR PHOTOVOLTAIC | OP | ... | 0 | 0 | 288.0000 | 0.0299 | NOT AVAILABLE | NOT AVAILABLE | 0 | 44.2972 | -92.7415 | POINT (-92.73593 44.29588) |
| 11809 | 11810 | 60834 | HWY 14 HOLDCO SOLAR CSG | 7647 COUNTRY CLUB ROAD W BYRON | BYRON | MN | 55920 | NOT AVAILABLE | SOLAR PHOTOVOLTAIC | OP | ... | 0 | 0 | 7943.0000 | 0.1813 | NOT AVAILABLE | NOT AVAILABLE | 0 | 44.0218 | -92.5922 | POINT (-92.59275 44.02356) |
8736 rows × 45 columns
US Power Plants Interactive Map¶
operational_powerplants_map = powerplants_df.explore(column="PRIM_FUEL", # make choropleth based on "BoroName" column
popup=False, # show all values in popup (on click)
tiles="CartoDB positron", # use "CartoDB positron" tiles
cmap="Set1", # use "Set1" matplotlib colormap
style_kwds=dict(color="black"),
marker_kwds= dict(radius=6),# use black outline)
scheme = 'EqualInterval',
k = 5
)
#ng_map
operational_powerplants_map
Make this Notebook Trusted to load map: File -> Trust Notebook